#coding:utf-8
import xlrd
import numpy as np
import cPickle
from scipy.io import savemat

excel = xlrd.open_workbook(u'hanggai_gaocheng.xlsx')
sheet = excel.sheets()[0]
X = sheet.col_values(4)
X = np.array(X[1:])
Y = sheet.col_values(7)
Y = np.array(Y[1:])
H = sheet.col_values(1)
H = np.array(H[1:])
#cPickle.dump([X,Y,H], open('hanggai.pkl','w'))
savemat('hanggai.mat', {'H':H, 'X':X, 'Y':Y})






